数据库、表分区

库建立文件组

alter database DDAPDnalab add filegroup Group2000
alter database DDAPDnalab add filegroup Group2001

库设置分区文件组

alter database DDAPDnalab add file 
(name=N'Time2000',filename=N'/var/opt/mssql/data/DDAPDnalab_DDAP_Data_Time2000.ndf',size=5Mb,filegrowth=5mb)
to filegroup Group2000
alter database DDAPDnalab add file 
(name=N'Time2001',filename=N'/var/opt/mssql/data/DDAPDnalab_DDAP_Data_Time2001.ndf',size=5Mb,filegrowth=5mb)
to filegroup Group2001

表创建分区，按某个字段设置边界后，放到对应的分区里